You can establish a connection to PostGIS in one of two ways: either in the Geospatial Administrator when a Schema is used or directly in the OpenCities Map Ribbon in a Design File.

Geospatial Administrator Connections to PostGIS

When defining a graphical source as a PostGIS connection in OpenCities Geospatial Administrator (GSA), the Build Connection dialog provides the database and User account options.

• Connection Name – The name of the graphical source
• Description – An optional description
• Host – The host computer on which the database is running
• Port - The port number for the connection (the default is 5432)
• Database – The database running on the selected host computer
• User – The PostGIS database user name
• Password – The PostGIS database password
• Use Windows Integrated Authentication – If checked, you will be logged in with your Windows username and password. Windows Integrated Authentication configuration should be established in order to use this option.

OpenCities Map Connections to PostGIS

The PostGIS Connect dialog can be opened directly from the Database Connection ribbon group in a Design File.

• User – The PostGIS user name
• Password – The PostGIS password
• Use Windows Integrated Authentication – If checked, you will be logged in with your Windows username and password. Windows Integrated Authentication configuration should be established in order to use this option.
• Host – The host computer on which the database is running
• Port - The port number for the connection (the default is 5432)
• Database – The database running on the selected host computer